package com.ossean.match.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.ossean.match.model.RelativeMemo;

public interface RelativeMemoDao {
	
	//批量获取帖子对象
	@Select("select * from job_requirements where id>#{startId} AND id<=#{endId}")
	public List<RelativeMemo> getMemoInfo(@Param("startId") int startId, @Param("endId") int endId);
	
	//获得最大帖子id
	@Select("select MAX(id) from job_requirements")
	public Integer getLastMemoId();
	
	@Select("select * from job_requirements where id = #{id}")
	public RelativeMemo getMemoById(@Param("id") int id);
	
}
